/*
 Navicat Premium Dump SQL

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 80405 (8.4.5)
 Source Host           : localhost:3306
 Source Schema         : book-library

 Target Server Type    : MySQL
 Target Server Version : 80405 (8.4.5)
 File Encoding         : 65001

 Date: 18/05/2025 16:24:12
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for book
-- ----------------------------
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book` (
  `book_id` bigint NOT NULL AUTO_INCREMENT COMMENT '图书的唯一标识符',
  `title` varchar(255) NOT NULL COMMENT '书名',
  `author` varchar(100) DEFAULT NULL COMMENT '作者',
  `isbn` varchar(60) NOT NULL,
  `publisher` varchar(100) DEFAULT NULL COMMENT '出版社',
  `publication_year` int DEFAULT NULL COMMENT '出版年份',
  `cover_url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '封面图片',
  `price` decimal(10,2) DEFAULT NULL COMMENT '价格',
  `category_id` bigint unsigned DEFAULT NULL COMMENT '图书分类号\n',
  `language` varchar(50) DEFAULT NULL COMMENT '图书语言',
  `total_copies` int unsigned DEFAULT '0' COMMENT '总副本数',
  `available_copies` int unsigned DEFAULT '0' COMMENT '可用副本数',
  `location` varchar(255) DEFAULT NULL COMMENT '馆藏地址',
  `status` tinyint unsigned DEFAULT '1' COMMENT '状态:0-未上架;1-上架',
  `description` text COMMENT '图书介绍',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `updated_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_by` varchar(60) DEFAULT NULL COMMENT '创建人',
  `updated_by` varchar(60) DEFAULT NULL COMMENT '更新人',
  `attachment_url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '图书附件URL',
  PRIMARY KEY (`book_id`),
  KEY `idx_isbn` (`isbn`),
  KEY `idx_author` (`author`)
) ENGINE=InnoDB AUTO_INCREMENT=173 DEFAULT CHARSET=utf8mb3 COMMENT='图书信息表';

-- ----------------------------
-- Records of book
-- ----------------------------
BEGIN;
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (4, '活着', '余华', '9787532742829', '作家出版社', 1993, '/site/images/4.png', 11.00, 1, '中文', 1, 1, '理科2室', 1, '讲述了一个普通人在中国历史变革中的苦难', NULL, '2025-05-08 09:59:55', '2025-04-21 22:52:37', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (5, '百年孤独', '加西亚·马尔克斯', '9787544258998', '南海出版公司', 1967, '/site/images/5.png', 30.50, 2, '法文', 1, 1, '理科2室', 2, '魔幻现实主义文学的代表作', NULL, '2025-05-08 09:59:57', '2025-04-22 17:23:16', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (6, '1984', '乔治·奥威尔', '9787532753315', '上海译文出版社', 1949, '/site/images/6.png', 13.00, 1, '法文', 1, 1, '理科2室', 2, '反乌托邦三部曲之一', NULL, '2025-05-08 10:00:01', '2025-04-21 22:52:37', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (7, '追风筝的人', '卡勒德·胡赛尼', '9787208061644', '上海人民出版社', 2003, '/site/images/7.png', 16.00, 2, '中文', 1, 1, '文科1室', 1, '描绘了阿富汗动荡时期的人性与救赎', NULL, '2025-05-08 10:00:07', '2025-04-24 11:22:58', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (8, '白夜行', '东野圭吾', '9787544267618', '南海出版公司', 1999, '/site/images/8.png', 12.00, 4, '9', NULL, 1, 'H区', NULL, '日本推理小说的杰作', NULL, '2025-05-08 10:00:09', '2025-04-21 22:52:37', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (9, '哈利·波特与魔法石', 'J.K.罗琳', '9787229059321', '人民文学出版社', 1997, '/site/images/9.png', 18.00, 2, '15', NULL, 1, 'I区', NULL, '哈利·波特系列的开篇之作', NULL, '2025-05-08 10:00:12', '2025-04-21 22:52:37', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (10, '小王子', '安托万·德·圣埃克苏佩里', '9787544256486', '天津人民出版社', 1943, '/site/images/10.png', 17.00, 2, '14', NULL, 1, 'J区', NULL, '法国经典童话，寓意深刻', NULL, '2025-05-08 10:00:16', '2025-04-21 22:52:37', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (11, '万历十五年', '黄仁宇', '9787108018957', '生活·读书·新知三联书店', 1981, '', 10.00, 4, '8', NULL, 1, 'K区', NULL, '以万历十五年为节点，探讨明朝的兴衰', NULL, '2025-04-21 11:54:37', '2025-04-21 22:52:37', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (12, '人类简史', '尤瓦尔·赫拉利', '9787508660752', '中信出版社', 2011, '', 14.00, 2, '法文', 1, 1, '文科2室', 2, '从大历史角度审视人类发展', NULL, '2025-04-21 11:54:37', '2025-04-24 12:20:33', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (13, '霍乱时期的爱情', '加西亚·马尔克斯', '9787544288230', '南海出版公司', 1985, '', 13.00, 4, '10', NULL, 1, 'M区', NULL, '讲述了一段跨越半个多世纪的爱情故事', NULL, '2025-04-21 11:54:37', '2025-04-21 22:52:37', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (14, '看见', '柴静', '9787549528291', '广西师范大学出版社', 2013, '', 12.00, 4, '英文', 2, 1, '文科1室', 2, '中国著名记者柴静的自述', NULL, '2025-04-21 11:54:37', '2025-04-26 19:53:38', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (15, '浪潮之巅', '吴军', '9787111406560', '电子工业出版社', 2016, '', 11.00, 8, '8', NULL, 1, 'O区', NULL, '计算机产业发展史', NULL, '2025-04-21 11:54:37', '2025-04-21 22:52:37', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (16, '平凡的世界', '路遥', '9787530216780', '人民文学出版社', 1986, '', 15.00, 5, '12', NULL, 1, 'P区', NULL, '中国当代城乡社会的巨大变迁', NULL, '2025-04-21 11:54:37', '2025-04-21 22:52:37', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (97, '哈利·波特与魔法石', 'J.K.罗琳', '9787229059321', '人民文学出版社', 1997, '', 18.00, 2, '英文', 21, 1, '理科2室', 2, '哈利·波特系列的开篇之作', NULL, '2025-05-01 18:20:40', '2025-04-26 19:53:52', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (99, '三体', '刘慈欣', '9787536692930', '重庆出版社', 2008, '/site/images/3.png', 15.00, 2, '日文', 4, 1, '文科2室', 2, '中国科幻文学的里程碑之作', NULL, '2025-05-08 10:00:32', '2025-04-21 23:00:14', NULL, NULL, '/6f040251-5fb3-4b38-8d55-b72136970c39_3.1  教育部 “新工科”研究与实践项目立项 2.pdf');
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (106, '行舟绿水中', '李凤利', '39393994544442', NULL, 2023, NULL, 30.50, NULL, '中文', NULL, NULL, '理科3号室', 1, NULL, NULL, '2025-04-24 08:06:08', '2025-04-24 08:06:08', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (107, '行舟绿水中', '李凤利', '39393994544442', NULL, 2023, NULL, 30.50, NULL, '中文', NULL, NULL, '理科3号室', 1, NULL, NULL, '2025-04-24 08:06:41', '2025-04-24 08:06:41', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (113, '迟到的春天', '234234', '2423423', '4234234', 1900, '/80fa35b9-fbe2-41dd-809f-9910b44bb248_IMG_4848.jpeg', NULL, 6, '日文', 1, 1, '文科1室', 1, '2341234', NULL, '2025-05-01 17:36:44', '2025-05-01 17:34:12', NULL, NULL, '/cc5e34c4-9165-472f-bdf0-5acd0a84d956_3.1  教育部 “新工科”研究与实践项目立项 2.pdf');
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (115, '新增图书1', '333', '33332423423', '中国文学出版社', 2023, '/a9864f55-6b72-4170-8989-352b284d5396_IMG_0133.JPG', NULL, 1, '中文', 1, 1, '理科1室', 1, NULL, NULL, '2025-05-01 18:20:26', '2025-05-01 18:04:39', NULL, NULL, '/010698da-6f9f-4d4f-8dd7-e1722b46074a_3.1  教育部 “新工科”研究与实践项目立项 2.pdf');
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (119, '新增图书1', '333', '33332423423', '中国文学出版社', 2023, NULL, NULL, 1, '中文', 1, 1, '理科1室', 1, NULL, NULL, '2025-05-02 09:15:20', '2025-05-02 09:15:20', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (120, '新增图书1', '333', '33332423423', '中国文学出版社', 2023, NULL, NULL, 1, '中文', 1, 1, '理科1室', 1, NULL, NULL, '2025-05-06 17:49:52', '2025-05-06 17:49:52', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (121, '新增图书1', '33333344444', '33332423423', '中国文学出版社', 2023, NULL, NULL, 1, '中文', 1, 1, '理科1室', 1, NULL, NULL, '2025-05-06 17:49:59', '2025-05-06 17:49:59', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (122, '新增图书1', '333bbb', '33332423423', '中国文学出版社', 2023, NULL, NULL, 1, '中文', 1, 1, '理科1室', 1, NULL, NULL, '2025-05-06 17:58:34', '2025-05-06 17:58:34', NULL, NULL, NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (123, '活着', '余华', '9787506365437', '作家出版社', 2012, 'https://cdn.example.com/covers/9787506365437.jpg', 38.00, 1, '中文', 8, 6, 'A区1排2架', 1, '现实主义经典小说，以小人物的视角展现生命的坚韧。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (124, '三体', '刘慈欣', '9787536692930', '重庆出版社', 2008, 'https://cdn.example.com/covers/9787536692930.jpg', 65.00, 2, '中文', 10, 8, 'B区4排6架', 1, '中国硬核科幻巅峰之作，描述人类与外星文明的首次接触。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (125, '平凡的世界', '路遥', '9787020024759', '人民文学出版社', 2005, 'https://cdn.example.com/covers/9787020024759.jpg', 42.50, 3, '中文', 12, 10, 'C区2排3架', 1, '描写中国社会转型期农村青年的奋斗与成长。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (126, '红楼梦', '曹雪芹', '9787020002207', '人民文学出版社', 1996, 'https://cdn.example.com/covers/9787020002207.jpg', 49.00, 3, '中文', 9, 8, 'A区3排5架', 1, '中国古典小说巅峰，描绘贾府四大家族的兴衰。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (127, '百年孤独', '加西亚·马尔克斯', '9787544269309', '南海出版公司', 2011, 'https://cdn.example.com/covers/9787544269309.jpg', 59.00, 1, '中文', 5, 4, 'B区1排4架', 1, '魔幻现实主义代表作, 讲述布恩迪亚家族百年传奇。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (128, '解忧杂货店', '东野圭吾', '9787544270879', '南海出版公司', 2014, 'https://cdn.example.com/covers/9787544270879.jpg', 36.80, 2, '中文', 7, 7, 'D区3排1架', 1, '信件穿越时间，温暖治愈人心的小说。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (129, '白夜行', '东野圭吾', '9787544242517', '南海出版公司', 2008, 'https://cdn.example.com/covers/9787544242517.jpg', 46.00, 4, '中文', 6, 6, 'A区4排2架', 1, '跨越19年的黑暗守护与成长。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (130, '时间简史', '斯蒂芬·霍金', '9787535724472', '湖南科技出版社', 2011, 'https://cdn.example.com/covers/9787535724472.jpg', 65.00, 5, '中文', 8, 7, 'E区1排3架', 1, '通俗解读宇宙起源和终极命运的科普巨著。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (131, '盗墓笔记', '南派三叔', '9787536692931', '重庆出版社', 2007, 'https://cdn.example.com/covers/9787536692931.jpg', 29.90, 2, '中文', 7, 5, 'C区4排1架', 1, '诡谲古墓探险, 吴邪三叔等人历险故事。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (132, '围城', '钱钟书', '9787020023585', '人民文学出版社', 1991, 'https://cdn.example.com/covers/9787020023585.jpg', 39.80, 3, '中文', 11, 10, 'A区2排3架', 1, '现代知识分子婚姻与人生讽刺喜剧。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (133, '许三观卖血记', '余华', '9787532751105', '作家出版社', 2012, 'https://cdn.example.com/covers/9787532751105.jpg', 35.00, 1, '中文', 5, 3, 'C区1排2架', 1, '底层小人物于苦难中坚韧生存的现实之书。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (134, '小王子', '圣埃克苏佩里', '9787539998312', '中国友谊出版公司', 2015, 'https://cdn.example.com/covers/9787539998312.jpg', 30.00, 4, '中文', 6, 6, 'A区3排4架', 1, '寓言体哲理小说,给孩子和成人的温暖童话。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (135, '追风筝的人', '卡勒德·胡赛尼', '9787208061644', '上海人民出版社', 2006, 'https://cdn.example.com/covers/9787208061644.jpg', 45.00, 1, '中文', 9, 7, 'C区2排5架', 1, '意义深远的亲情与救赎故事，感动无数读者。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (136, '皮囊', '蔡崇达', '9787549510987', '新星出版社', 2014, 'https://cdn.example.com/covers/9787549510987.jpg', 32.00, 3, '中文', 4, 3, 'B区5排2架', 1, '关于亲情、成长与面对自我的散文集。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (137, '解体诸因', '刘慈欣', '9787536693821', '重庆出版社', 2011, 'https://cdn.example.com/covers/9787536693821.jpg', 52.00, 5, '中文', 3, 2, 'D区2排4架', 1, '短篇科幻，展现作者丰富想象力与思考。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (138, '目送', '龙应台', '9787535482051', '生活·读书·新知三联书店', 2009, 'https://cdn.example.com/covers/9787535482051.jpg', 44.80, 7, '中文', 8, 8, 'E区1排2架', 1, '温情散文，体会人生不同离合的深情体悟。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (139, '我们仨', '杨绛', '9787108011116', '生活·读书·新知三联书店', 2003, 'https://cdn.example.com/covers/9787108011116.jpg', 29.00, 7, '中文', 5, 3, 'A区1排6架', 1, '中国知识分子家庭真情回忆录，感人至深。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (140, '半小时漫画中国史', '陈磊', '9787201122199', '天津人民出版社', 2017, 'https://cdn.example.com/covers/9787201122199.jpg', 48.00, 6, '中文', 10, 10, 'B区3排4架', 1, '用漫画幽默方式讲述中国史，让读史变得轻松有趣。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (141, '大卫·科波菲尔', '查尔斯·狄更斯', '9787020028740', '人民文学出版社', 2003, 'https://cdn.example.com/covers/9787020028740.jpg', 42.00, 8, '中文', 5, 5, 'C区2排2架', 1, '维多利亚时代成长小说，描写人生悲欢。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (142, '嫌疑人X的献身', '东野圭吾', '9787544242516', '南海出版公司', 2009, 'https://cdn.example.com/covers/9787544242516.jpg', 39.80, 4, '中文', 7, 7, 'D区2排1架', 1, '天才数学家与警察智慧的较量，推理文学经典。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (143, '明朝那些事儿', '当年明月', '9787505722460', '中国友谊出版公司', 2009, 'https://cdn.example.com/covers/9787505722460.jpg', 88.00, 6, '中文', 9, 9, 'A区6排2架', 1, '以历史小说手法解读明朝，妙趣横生。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (144, '岛上书店', '加布瑞埃拉·泽文', '9787539982830', '江苏凤凰文艺出版社', 2015, 'https://cdn.example.com/covers/9787539982830.jpg', 34.90, 2, '中文', 4, 4, 'C区5排3架', 1, '书香治愈系小说，引发对生活与阅读的思考。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (145, '嫌疑人X的献身（新版）', '东野圭吾', '9787544291170', '南海出版公司', 2016, 'https://cdn.example.com/covers/9787544291170.jpg', 42.00, 4, '中文', 3, 1, 'C区2排1架', 1, '新译本更贴近推理原著，续写天才对决。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (146, '遥远的救世主', '豆豆', '9787540213657', '作家出版社', 2005, 'https://cdn.example.com/covers/9787540213657.jpg', 39.00, 10, '中文', 8, 7, 'B区1排3架', 1, '都市权谋小说极具魅力，央视同名热播剧原著。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (147, '天龙八部', '金庸', '9787020009556', '人民文学出版社', 1998, 'https://cdn.example.com/covers/9787020009556.jpg', 89.00, 9, '中文', 10, 8, 'A区7排4架', 1, '武侠巨著，义与爱的极致书写。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (148, '射雕英雄传', '金庸', '9787020024757', '人民文学出版社', 2001, 'https://cdn.example.com/covers/9787020024757.jpg', 76.00, 9, '中文', 6, 6, 'A区8排3架', 1, '金庸武侠代表作之一，描写侠义与家国。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (149, '雪中悍刀行', '烽火戏诸侯', '9787539958323', '湖北少年儿童出版社', 2016, 'https://cdn.example.com/covers/9787539958323.jpg', 69.80, 9, '中文', 5, 2, 'D区4排5架', 1, '新派武侠热血传奇网络小说改编。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (150, '嫌疑人X的献身（特别版）', '东野圭吾', '9787544242514', '南海出版公司', 2015, 'https://cdn.example.com/covers/9787544242514.jpg', 45.00, 4, '中文', 4, 4, 'A区4排3架', 1, '限量纪念版，新增人物访谈。', '库存充足', '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (151, '我们生活在巨大的差距里', '韩松落', '9787533944988', '南海出版公司', 2013, 'https://cdn.example.com/covers/9787533944988.jpg', 29.90, 8, '中文', 5, 4, 'B区5排1架', 1, '散文集，洞察行业与人生。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (152, '明朝那些事儿（全七册）', '当年明月', '9787505722469', '中国友谊出版公司', 2008, 'https://cdn.example.com/covers/9787505722469.jpg', 99.00, 6, '中文', 12, 11, 'B区6排5架', 1, '全本历史通俗读物，明史新解。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (153, '嫌疑人X的献身（纪念版）', '东野圭吾', '9787544264806', '南海出版公司', 2018, 'https://cdn.example.com/covers/9787544264806.jpg', 49.80, 4, '中文', 5, 4, 'B区4排2架', 1, '本格推理力作，全新装帧纪念版。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (154, '摆渡人', '克莱儿·麦克福尔', '9787540468796', '百花洲文艺出版社', 2015, 'https://cdn.example.com/covers/9787540468796.jpg', 33.80, 2, '中文', 5, 5, 'D区2排3架', 1, '治愈人生恐惧与悲伤，豆瓣高评分小说。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (155, '沉默的大多数', '王小波', '9787506365437', '中国青年出版社', 2012, 'https://cdn.example.com/covers/9787506365438.jpg', 35.00, 7, '中文', 6, 5, 'E区3排2架', 1, '以独特幽默和思想深度著称的杂文集。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (156, '哈利·波特与魔法石', 'J.K.罗琳', '9787020196393', '人民文学出版社', 2008, 'https://cdn.example.com/covers/9787020196393.jpg', 56.00, 4, '中文', 11, 10, 'B区7排4架', 1, '全球畅销魔幻小说第一部，开启魔法世界冒险。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (157, '人类简史', '尤瓦尔·赫拉利', '9787508647357', '中信出版社', 2014, 'https://cdn.example.com/covers/9787508647357.jpg', 75.00, 5, '中文', 8, 7, 'A区5排1架', 1, '宏观视角描绘人类进化及社会变化。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (158, '动物农庄', '乔治·奥威尔', '9787506394864', '花城出版社', 2015, 'https://cdn.example.com/covers/9787506394864.jpg', 28.00, 8, '中文', 6, 6, 'D区3排2架', 1, '政治寓言文学，经久不衰的社会讽喻。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (159, '孤独六讲', '蒋勋', '9787532734498', '湖南文艺出版社', 2008, 'https://cdn.example.com/covers/9787532734498.jpg', 36.00, 7, '中文', 5, 2, 'E区2排5架', 1, '“孤独人生”细致剖析，安抚心灵的治愈佳作。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (160, '白鹿原', '陈忠实', '9787530218662', '人民文学出版社', 2012, 'https://cdn.example.com/covers/9787530218662.jpg', 55.00, 1, '中文', 9, 7, 'A区5排3架', 1, '中国农村变迁史诗，白家鹿家两代沉浮。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (161, '苏菲的世界', '乔斯坦·贾德', '9787532725694', '作家出版社', 2007, 'https://cdn.example.com/covers/9787532725694.jpg', 45.80, 5, '中文', 3, 3, 'C区8排2架', 1, '哲学启蒙小说，探寻人生终极问题。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (162, '狼图腾', '姜戎', '9787506104946', '长江文艺出版社', 2004, 'https://cdn.example.com/covers/9787506104946.jpg', 32.50, 2, '中文', 8, 8, 'B区9排4架', 1, '草原民族与狼群的相互纠缠与哲理。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (163, '文化苦旅', '余秋雨', '9787020002201', '人民文学出版社', 1992, 'https://cdn.example.com/covers/9787020002201.jpg', 29.90, 8, '中文', 7, 5, 'E区6排1架', 1, '行走中国名胜，深度文化随笔。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (164, '房思琪的初恋乐园', '林奕含', '9787550023858', '北京联合出版公司', 2016, 'https://cdn.example.com/covers/9787550023858.jpg', 33.90, 1, '中文', 3, 2, 'D区5排1架', 1, '勇敢讲述女性伤痕，直面社会冷漠。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (165, '从你的全世界路过', '张嘉佳', '9787540468795', '湖南文艺出版社', 2013, 'https://cdn.example.com/covers/9787540468795.jpg', 32.00, 3, '中文', 7, 7, 'A区7排5架', 1, '温暖治愈的都市爱情故事合集。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (166, '大江大河', '阿耐', '9787530218679', '北京联合出版公司', 2018, 'https://cdn.example.com/covers/9787530218679.jpg', 38.50, 2, '中文', 4, 3, 'C区1排5架', 1, '改革开放时期社会变革长篇小说。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (167, '刀锋', '毛姆', '9787222037724', '重庆出版社', 2014, 'https://cdn.example.com/covers/9787222037724.jpg', 35.00, 6, '中文', 4, 2, 'D区7排1架', 1, '探索灵魂的救赎与人生意义。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (168, '蛙', '莫言', '9787532745075', '上海文艺出版社', 2009, 'https://cdn.example.com/covers/9787532745075.jpg', 55.00, 1, '中文', 6, 6, 'E区7排2架', 1, '探讨生育、权力、人性的复杂问题。', '', '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (169, '平如美棠：我们俩', '饶平如', '9787539980707', '江苏文艺出版社', 2013, 'https://cdn.example.com/covers/9787539980707.jpg', 25.00, 7, '中文', 3, 3, 'C区9排2架', 0, '一生只爱一人，真实动人的爱情回忆录。', '首版已售罄', '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (170, '浮生六记', '沈复', '9787101054844', '中华书局', 2009, 'https://cdn.example.com/covers/9787101054844.jpg', 28.00, 8, '中文', 6, 5, 'A区9排3架', 1, '清朝名士沈复的自传体散文集，淡雅隽永。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (171, '嫌疑人X的献身（精读版）', '东野圭吾', '9787544269302', '南海出版公司', 2020, 'https://cdn.example.com/covers/9787544269302.jpg', 48.00, 4, '中文', 5, 4, 'B区8排3架', 1, '专业深度解读，推理解谜爱好者首选。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
INSERT INTO `book` (`book_id`, `title`, `author`, `isbn`, `publisher`, `publication_year`, `cover_url`, `price`, `category_id`, `language`, `total_copies`, `available_copies`, `location`, `status`, `description`, `remark`, `updated_time`, `created_time`, `created_by`, `updated_by`, `attachment_url`) VALUES (172, '活着（典藏版）', '余华', '9787506366948', '作家出版社', 2020, 'https://cdn.example.com/covers/9787506366948.jpg', 55.00, 1, '中文', 10, 9, 'A区10排1架', 1, '余华经典，被誉为最具治愈力的中国小说之一。', NULL, '2025-05-08 11:51:26', '2025-05-08 11:51:26', 'admin', 'admin', NULL);
COMMIT;

-- ----------------------------
-- Table structure for book_category
-- ----------------------------
DROP TABLE IF EXISTS `book_category`;
CREATE TABLE `book_category` (
  `category_id` bigint NOT NULL AUTO_INCREMENT COMMENT '图书分类ID',
  `category_name` varchar(100) NOT NULL COMMENT '图书分类名称',
  `status` tinyint DEFAULT '1' COMMENT '分类状态：1=启用，0=禁用',
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_by` varchar(60) DEFAULT NULL COMMENT '创建人',
  `updated_by` varchar(60) DEFAULT NULL COMMENT '更新人',
  `description` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`category_id`),
  KEY `idx_status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb3 COMMENT='图书分类表';

-- ----------------------------
-- Records of book_category
-- ----------------------------
BEGIN;
INSERT INTO `book_category` (`category_id`, `category_name`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`, `description`) VALUES (1, '计算机科学', 1, '2025-04-01 10:30:00', '2025-04-01 10:30:00', 'admin', 'admin', NULL);
INSERT INTO `book_category` (`category_id`, `category_name`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`, `description`) VALUES (2, '文学小说', 1, '2025-04-01 10:35:00', '2025-04-22 11:49:44', 'admin', 'admin', NULL);
INSERT INTO `book_category` (`category_id`, `category_name`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`, `description`) VALUES (3, '历史传记', 1, '2025-04-01 10:40:00', '2025-04-22 11:49:01', 'admin', 'admin', NULL);
INSERT INTO `book_category` (`category_id`, `category_name`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`, `description`) VALUES (4, '自然科学', 1, '2025-04-01 10:45:00', '2025-04-01 10:45:00', 'admin', 'admin', NULL);
INSERT INTO `book_category` (`category_id`, `category_name`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`, `description`) VALUES (5, '工程技术', 1, '2025-04-01 10:50:00', '2025-04-01 10:50:00', 'admin', 'admin', NULL);
INSERT INTO `book_category` (`category_id`, `category_name`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`, `description`) VALUES (6, '经济管理', 1, '2025-04-01 10:55:00', '2025-04-01 10:55:00', 'admin', 'admin', NULL);
INSERT INTO `book_category` (`category_id`, `category_name`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`, `description`) VALUES (7, '艺术设计', 1, '2025-04-01 11:00:00', '2025-04-01 11:00:00', 'admin', 'admin', NULL);
INSERT INTO `book_category` (`category_id`, `category_name`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`, `description`) VALUES (50, 'AI人工智能', 1, '2025-05-01 22:37:04', '2025-05-01 22:37:04', NULL, NULL, '图强化学习算法');
INSERT INTO `book_category` (`category_id`, `category_name`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`, `description`) VALUES (51, 'AI人工智能2', 0, '2025-05-01 22:43:57', '2025-05-01 22:54:18', NULL, NULL, '图强化学习算法');
INSERT INTO `book_category` (`category_id`, `category_name`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`, `description`) VALUES (52, 'AI人工智能23', 0, '2025-05-01 22:43:59', '2025-05-01 22:48:51', NULL, NULL, '图强化4');
INSERT INTO `book_category` (`category_id`, `category_name`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`, `description`) VALUES (53, 'AI人工智能', 0, '2025-05-01 22:45:39', '2025-05-01 22:48:43', NULL, NULL, '图强化学习算法');
INSERT INTO `book_category` (`category_id`, `category_name`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`, `description`) VALUES (56, 'AI人工智能', 1, '2025-05-02 10:04:48', '2025-05-02 10:04:48', NULL, NULL, '图强化学习算法');
COMMIT;

-- ----------------------------
-- Table structure for book_copy
-- ----------------------------
DROP TABLE IF EXISTS `book_copy`;
CREATE TABLE `book_copy` (
  `copy_id` bigint NOT NULL AUTO_INCREMENT COMMENT '副本ID',
  `book_id` bigint NOT NULL COMMENT '图书ID',
  `barcode` varchar(255) NOT NULL COMMENT '条形码',
  `location` varchar(255) DEFAULT NULL COMMENT '存放位置',
  `status` tinyint DEFAULT '1' COMMENT '副本状态：1=在库，0=借出, 2=遗失',
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`copy_id`),
  UNIQUE KEY `barcode` (`barcode`)
) ENGINE=InnoDB AUTO_INCREMENT=264 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='图书副本表';

-- ----------------------------
-- Records of book_copy
-- ----------------------------
BEGIN;
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (1, 1, '1234567890123', 'Shelf A1', 1, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (2, 2, '1234567890124', 'Shelf A2', 9, '2024-12-14 23:24:53', '2025-05-06 11:42:15');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (3, 3, '1234567890125', 'Shelf B1', 1, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (4, 4, '1234567890126', 'Shelf B2', 0, '2024-12-14 23:24:53', '2025-05-06 11:41:50');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (5, 4, '1234567890127', 'Shelf C1', 0, '2024-12-14 23:24:53', '2025-05-07 11:03:12');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (6, 6, '1234567890128', 'Shelf C2', 2, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (7, 7, '1234567890129', 'Shelf D1', 0, '2024-12-14 23:24:53', '2025-05-06 11:41:49');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (8, 4, '1234567890130', 'Shelf D2', 2, '2024-12-14 23:24:53', '2025-05-07 11:03:14');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (9, 9, '1234567890131', 'Shelf E1', 1, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (10, 10, '1234567890132', 'Shelf E2', 2, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (11, 4, '1234567890133', 'Shelf F1', 1, '2024-12-14 23:24:53', '2025-05-07 11:03:16');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (12, 12, '1234567890134', 'Shelf F2', 2, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (13, 13, '1234567890135', 'Shelf G1', 1, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (14, 4, '1234567890136', 'Shelf G2', 2, '2024-12-14 23:24:53', '2025-05-07 11:03:18');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (15, 15, '1234567890137', 'Shelf H1', 0, '2024-12-14 23:24:53', '2025-05-06 11:41:45');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (16, 16, '1234567890138', 'Shelf H2', 0, '2024-12-14 23:24:53', '2025-05-06 11:41:47');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (17, 5, '1234567890139', 'Shelf I1', 0, '2024-12-14 23:24:53', '2025-05-07 11:03:19');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (18, 18, '1234567890140', 'Shelf I2', 0, '2024-12-14 23:24:53', '2025-05-06 11:42:09');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (19, 19, '1234567890141', 'Shelf J1', 1, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (20, 20, '1234567890142', 'Shelf J2', 0, '2024-12-14 23:24:53', '2025-05-06 11:42:20');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (21, 5, '1234567890143', 'Shelf K1', 0, '2024-12-14 23:24:53', '2025-05-07 11:03:21');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (22, 22, '1234567890144', 'Shelf K2', 2, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (23, 5, '1234567890145', 'Shelf L1', 0, '2024-12-14 23:24:53', '2025-05-07 11:03:22');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (24, 6, '1234567890146', 'Shelf L2', 0, '2024-12-14 23:24:53', '2025-05-07 11:03:23');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (25, 5, '1234567890147', 'Shelf M1', 1, '2024-12-14 23:24:53', '2025-05-07 11:03:25');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (26, 26, '1234567890148', 'Shelf M2', 2, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (27, 27, '1234567890149', 'Shelf N1', 1, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (28, 28, '1234567890150', 'Shelf N2', 2, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (29, 29, '1234567890151', 'Shelf O1', 1, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (30, 30, '1234567890152', 'Shelf O2', 2, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (31, 31, '1234567890153', 'Shelf P1', 1, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (32, 6, '1234567890154', 'Shelf P2', 2, '2024-12-14 23:24:53', '2025-05-07 11:03:27');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (33, 33, '1234567890155', 'Shelf Q1', 1, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (34, 5, '1234567890156', 'Shelf Q2', 2, '2024-12-14 23:24:53', '2025-05-07 11:03:29');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (35, 35, '1234567890157', 'Shelf R1', 0, '2024-12-14 23:24:53', '2025-05-06 11:42:23');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (36, 36, '1234567890158', 'Shelf R2', 0, '2024-12-14 23:24:53', '2025-05-06 11:42:23');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (37, 37, '1234567890159', 'Shelf S1', 1, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (38, 38, '1234567890160', 'Shelf S2', 2, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (39, 39, '1234567890161', 'Shelf T1', 0, '2024-12-14 23:24:53', '2025-05-06 11:42:25');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (40, 40, '1234567890162', 'Shelf T2', 0, '2024-12-14 23:24:53', '2025-05-06 11:42:25');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (41, 41, '1234567890163', 'Shelf U1', 1, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (42, 42, '1234567890164', 'Shelf U2', 2, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (43, 43, '1234567890165', 'Shelf V1', 0, '2024-12-14 23:24:53', '2025-05-06 11:42:26');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (44, 44, '1234567890166', 'Shelf V2', 0, '2024-12-14 23:24:53', '2025-05-06 11:42:26');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (45, 45, '1234567890167', 'Shelf W1', 1, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (46, 46, '1234567890168', 'Shelf W2', 0, '2024-12-14 23:24:53', '2025-05-06 11:42:28');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (47, 47, '1234567890169', 'Shelf X1', 0, '2024-12-14 23:24:53', '2025-05-06 11:42:28');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (48, 48, '1234567890170', 'Shelf X2', 0, '2024-12-14 23:24:53', '2025-05-06 11:42:32');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (49, 49, '1234567890171', 'Shelf Y1', 0, '2024-12-14 23:24:53', '2025-05-06 11:42:32');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (50, 50, '1234567890172', 'Shelf Y2', 2, '2024-12-14 23:24:53', '2024-12-14 23:24:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (52, 11, 'CP250506174646011', '文科1室1书架', 1, '2025-05-06 17:47:20', '2025-05-06 17:47:20');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (53, 4, 'CP25050712010040', '文科室1号架', 0, '2025-05-07 12:01:25', '2025-05-07 12:01:25');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (54, 15, 'CP25050716574825', 'testBookcopy1@za.com.cn', 0, '2025-05-07 16:57:51', '2025-05-07 16:57:51');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (55, 16, 'CP25050716584184', '文科1室1书架', 1, '2025-05-07 16:58:49', '2025-05-07 16:58:49');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (56, 12, 'CP25050809471953', '文科1室1书架', 1, '2025-05-08 09:47:23', '2025-05-08 09:47:23');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (57, 99, 'CP25050809491096', '文科1室1书架', 0, '2025-05-08 09:49:12', '2025-05-08 09:49:12');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (58, 99, 'CP25050809503308', '文科1室1书架', 1, '2025-05-08 09:50:35', '2025-05-08 09:50:35');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (59, 99, 'CP25050809515648', '文科1室1书架', 0, '2025-05-08 09:52:10', '2025-05-08 09:52:10');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (60, 12, 'CP25050809525606', '文科1室1书架', 0, '2025-05-08 09:53:03', '2025-05-08 09:53:03');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (61, 16, 'CP25050810013063', '文科1室1书架', 0, '2025-05-08 10:01:32', '2025-05-08 10:01:32');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (62, 99, 'CP25050810015080', '文科1室1书架', 0, '2025-05-08 10:01:53', '2025-05-08 10:01:53');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (63, 148, 'CP250515115949066', '文科1室1书架', 0, '2025-05-15 11:59:58', '2025-05-15 11:59:58');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (64, 126, 'CP250515120017002', '文科1室1书架', 0, '2025-05-15 12:00:20', '2025-05-15 12:00:20');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (66, 126, 'CP20240515066', 'A区3排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (67, 127, 'CP20240515067', 'B区1排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (68, 128, 'CP20240515068', 'D区3排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (69, 129, 'CP20240515069', 'A区4排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (70, 130, 'CP20240515070', 'E区1排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (71, 131, 'CP20240515071', 'C区4排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (72, 132, 'CP20240515072', 'A区2排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (73, 133, 'CP20240515073', 'C区1排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (74, 134, 'CP20240515074', 'A区3排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (75, 135, 'CP20240515075', 'C区2排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (76, 136, 'CP20240515076', 'B区5排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (77, 137, 'CP20240515077', 'D区2排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (78, 138, 'CP20240515078', 'E区1排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (79, 139, 'CP20240515079', 'A区1排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (80, 140, 'CP20240515080', 'B区3排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (81, 141, 'CP20240515081', 'C区2排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (82, 142, 'CP20240515082', 'D区2排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (83, 123, 'CP20240515083', 'A区2排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (84, 124, 'CP20240515084', 'B区3排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (85, 125, 'CP20240515085', 'C区4排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (86, 126, 'CP20240515086', 'A区4排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (87, 127, 'CP20240515087', 'D区2排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (88, 128, 'CP20240515088', 'B区1排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (89, 129, 'CP20240515089', 'C区4排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (90, 130, 'CP20240515090', 'E区3排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (91, 131, 'CP20240515091', 'A区1排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (92, 132, 'CP20240515092', 'B区4排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (93, 133, 'CP20240515093', 'D区3排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (94, 134, 'CP20240515094', 'C区3排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (95, 135, 'CP20240515095', 'B区2排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (96, 136, 'CP20240515096', 'A区5排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (97, 137, 'CP20240515097', 'D区1排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (98, 138, 'CP20240515098', 'B区4排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (99, 139, 'CP20240515099', 'E区3排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (100, 140, 'CP20240515100', 'C区3排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (101, 141, 'CP20240515101', 'A区2排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (102, 142, 'CP20240515102', 'E区4排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (103, 123, 'CP20240515103', 'B区1排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (104, 124, 'CP20240515104', 'C区1排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (105, 125, 'CP20240515105', 'A区5排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (106, 126, 'CP20240515106', 'D区2排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (107, 127, 'CP20240515107', 'C区4排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (108, 128, 'CP20240515108', 'B区3排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (109, 129, 'CP20240515109', 'E区1排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (110, 130, 'CP20240515110', 'A区1排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (111, 131, 'CP20240515111', 'D区4排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (112, 132, 'CP20240515112', 'C区2排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (113, 133, 'CP20240515113', 'B区4排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (114, 134, 'CP20240515114', 'E区4排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (115, 135, 'CP20240515115', 'D区1排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (116, 136, 'CP20240515116', 'A区2排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (117, 137, 'CP20240515117', 'B区2排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (118, 138, 'CP20240515118', 'C区5排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (119, 139, 'CP20240515119', 'A区3排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (120, 140, 'CP20240515120', 'D区2排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (121, 141, 'CP20240515121', 'E区2排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (122, 142, 'CP20240515122', 'C区1排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (123, 123, 'CP20240515123', 'B区3排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (124, 124, 'CP20240515124', 'D区2排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (125, 125, 'CP20240515125', 'E区2排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (126, 126, 'CP20240515126', 'D区4排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (127, 127, 'CP20240515127', 'A区4排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (128, 128, 'CP20240515128', 'B区5排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (129, 129, 'CP20240515129', 'C区3排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (130, 130, 'CP20240515130', 'E区1排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (131, 131, 'CP20240515131', 'D区4排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (132, 132, 'CP20240515132', 'A区5排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (133, 133, 'CP20240515133', 'B区2排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (134, 134, 'CP20240515134', 'C区1排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (135, 135, 'CP20240515135', 'A区2排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (136, 136, 'CP20240515136', 'B区5排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (137, 137, 'CP20240515137', 'E区3排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (138, 138, 'CP20240515138', 'D区5排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (139, 139, 'CP20240515139', 'A区4排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (140, 140, 'CP20240515140', 'C区3排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (141, 141, 'CP20240515141', 'E区2排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (142, 142, 'CP20240515142', 'E区5排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (143, 123, 'CP20240515143', 'B区2排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (144, 124, 'CP20240515144', 'C区2排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (145, 125, 'CP20240515145', 'A区4排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (146, 126, 'CP20240515146', 'E区5排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (147, 127, 'CP20240515147', 'B区3排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (148, 128, 'CP20240515148', 'C区3排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (149, 129, 'CP20240515149', 'A区5排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (150, 130, 'CP20240515150', 'E区4排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (151, 131, 'CP20240515151', 'B区5排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (152, 132, 'CP20240515152', 'D区3排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (153, 133, 'CP20240515153', 'A区2排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (154, 134, 'CP20240515154', 'E区2排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (155, 135, 'CP20240515155', 'C区5排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (156, 136, 'CP20240515156', 'D区5排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (157, 137, 'CP20240515157', 'A区1排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (158, 138, 'CP20240515158', 'B区3排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (159, 139, 'CP20240515159', 'C区2排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (160, 140, 'CP20240515160', 'E区1排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (161, 141, 'CP20240515161', 'A区3排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (162, 142, 'CP20240515162', 'B区4排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (163, 123, 'CP20240515163', 'D区5排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (164, 124, 'CP20240515164', 'C区4排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (165, 125, 'CP20240515165', 'B区1排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (166, 126, 'CP20240515166', 'E区5排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (167, 127, 'CP20240515167', 'A区3排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (168, 128, 'CP20240515168', 'D区1排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (169, 129, 'CP20240515169', 'B区3排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (170, 130, 'CP20240515170', 'C区2排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (171, 131, 'CP20240515171', 'A区5排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (172, 132, 'CP20240515172', 'E区3排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (173, 133, 'CP20240515173', 'C区5排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (174, 134, 'CP20240515174', 'B区2排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (175, 135, 'CP20240515175', 'A区3排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (176, 136, 'CP20240515176', 'D区5排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (177, 137, 'CP20240515177', 'E区4排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (178, 138, 'CP20240515178', 'C区3排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (179, 139, 'CP20240515179', 'B区5排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (180, 140, 'CP20240515180', 'E区5排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (181, 141, 'CP20240515181', 'A区2排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (182, 142, 'CP20240515182', 'D区2排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (183, 123, 'CP20240515183', 'C区4排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (184, 124, 'CP20240515184', 'B区2排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (185, 125, 'CP20240515185', 'D区1排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (186, 126, 'CP20240515186', 'E区2排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (187, 127, 'CP20240515187', 'B区3排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (188, 128, 'CP20240515188', 'D区3排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (189, 129, 'CP20240515189', 'A区1排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (190, 130, 'CP20240515190', 'C区2排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (191, 131, 'CP20240515191', 'B区1排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (192, 132, 'CP20240515192', 'A区4排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (193, 133, 'CP20240515193', 'E区3排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (194, 134, 'CP20240515194', 'A区1排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (195, 135, 'CP20240515195', 'C区5排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (196, 136, 'CP20240515196', 'B区2排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (197, 137, 'CP20240515197', 'A区3排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (198, 138, 'CP20240515198', 'C区4排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (199, 139, 'CP20240515199', 'D区4排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (200, 140, 'CP20240515200', 'A区5排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (201, 141, 'CP20240515201', 'E区2排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (202, 142, 'CP20240515202', 'D区2排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (203, 123, 'CP20240515203', 'B区4排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (204, 124, 'CP20240515204', 'E区5排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (205, 125, 'CP20240515205', 'A区2排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (206, 126, 'CP20240515206', 'C区3排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (207, 127, 'CP20240515207', 'D区5排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (208, 128, 'CP20240515208', 'B区1排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (209, 129, 'CP20240515209', 'C区4排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (210, 130, 'CP20240515210', 'E区1排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (211, 131, 'CP20240515211', 'A区4排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (212, 132, 'CP20240515212', 'D区3排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (213, 133, 'CP20240515213', 'C区2排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (214, 134, 'CP20240515214', 'B区3排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (215, 135, 'CP20240515215', 'E区5排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (216, 136, 'CP20240515216', 'D区1排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (217, 137, 'CP20240515217', 'A区1排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (218, 138, 'CP20240515218', 'B区5排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (219, 139, 'CP20240515219', 'C区1排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (220, 140, 'CP20240515220', 'A区4排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (221, 141, 'CP20240515221', 'E区2排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (222, 142, 'CP20240515222', 'D区4排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (223, 123, 'CP20240515223', 'C区2排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (224, 124, 'CP20240515224', 'B区1排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (225, 125, 'CP20240515225', 'E区3排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (226, 126, 'CP20240515226', 'A区5排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (227, 127, 'CP20240515227', 'D区2排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (228, 128, 'CP20240515228', 'C区3排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (229, 129, 'CP20240515229', 'A区1排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (230, 130, 'CP20240515230', 'B区2排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (231, 131, 'CP20240515231', 'C区2排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (232, 132, 'CP20240515232', 'A区4排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (233, 133, 'CP20240515233', 'D区1排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (234, 134, 'CP20240515234', 'E区4排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (235, 135, 'CP20240515235', 'B区5排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (236, 136, 'CP20240515236', 'C区5排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (237, 137, 'CP20240515237', 'A区2排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (238, 138, 'CP20240515238', 'E区3排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (239, 139, 'CP20240515239', 'B区3排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (240, 140, 'CP20240515240', 'C区4排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (241, 141, 'CP20240515241', 'D区5排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (242, 142, 'CP20240515242', 'A区3排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (243, 123, 'CP20240515243', 'E区2排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (244, 124, 'CP20240515244', 'B区4排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (245, 125, 'CP20240515245', 'C区1排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (246, 126, 'CP20240515246', 'A区2排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (247, 127, 'CP20240515247', 'D区3排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (248, 128, 'CP20240515248', 'A区5排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (249, 129, 'CP20240515249', 'C区3排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (250, 130, 'CP20240515250', 'B区2排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (251, 131, 'CP20240515251', 'D区2排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (252, 132, 'CP20240515252', 'C区4排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (253, 133, 'CP20240515253', 'E区5排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (254, 134, 'CP20240515254', 'B区3排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (255, 135, 'CP20240515255', 'A区1排1架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (256, 136, 'CP20240515256', 'C区4排6架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (257, 137, 'CP20240515257', 'A区2排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (258, 138, 'CP20240515258', 'D区4排5架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (259, 139, 'CP20240515259', 'B区5排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (260, 140, 'CP20240515260', 'C区1排2架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (261, 141, 'CP20240515261', 'A区3排3架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (262, 142, 'CP20240515262', 'D区5排4架', 1, '2025-05-15 10:00:00', '2025-05-15 10:00:00');
INSERT INTO `book_copy` (`copy_id`, `book_id`, `barcode`, `location`, `status`, `created_time`, `updated_time`) VALUES (263, 156, 'CP250516121354028', 'testBookcopy1@za.com.cn', 0, '2025-05-16 12:13:57', '2025-05-16 12:13:57');
COMMIT;

-- ----------------------------
-- Table structure for borrow_record
-- ----------------------------
DROP TABLE IF EXISTS `borrow_record`;
CREATE TABLE `borrow_record` (
  `record_id` bigint NOT NULL AUTO_INCREMENT COMMENT '借阅记录ID',
  `copy_id` bigint NOT NULL COMMENT '图书副本ID',
  `reader_id` bigint NOT NULL COMMENT '读者ID',
  `borrow_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '借阅日期',
  `due_date` datetime NOT NULL COMMENT '应还日期',
  `return_date` datetime DEFAULT NULL COMMENT '实际还书日期',
  `overdue_days` int DEFAULT '0' COMMENT '逾期天数',
  `status` tinyint DEFAULT '1' COMMENT '借阅状态：1=借出中，0=已还',
  `is_overdue` tinyint(1) DEFAULT NULL COMMENT '是否逾期',
  `fine` decimal(10,2) DEFAULT '0.00' COMMENT '罚款金额',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_by` varchar(60) DEFAULT NULL COMMENT '创建人',
  `updated_by` varchar(60) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`record_id`),
  KEY `idx_copy_id` (`copy_id`),
  KEY `idx_reader_id` (`reader_id`)
) ENGINE=InnoDB AUTO_INCREMENT=601 DEFAULT CHARSET=utf8mb3 COMMENT='借阅记录表';

-- ----------------------------
-- Records of borrow_record
-- ----------------------------
BEGIN;
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (1, 1001, 1, '2025-04-01 14:00:00', '2025-04-16 14:00:00', '2025-04-15 14:00:00', 0, 0, 0, 0.00, '按时归还', '2025-04-01 14:00:00', '2025-04-15 14:00:00', 'librarian1', 'librarian1');
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (2, 1002, 2, '2025-04-02 09:30:00', '2025-04-17 09:30:00', NULL, 0, 1, 0, 0.00, '借阅中', '2025-04-02 09:30:00', '2025-04-02 09:30:00', 'librarian2', 'librarian2');
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (3, 1003, 3, '2025-04-03 11:15:00', '2025-04-18 11:15:00', '2025-04-20 11:15:00', 2, 0, 1, 1.00, '逾期归还，已罚款', '2025-04-03 11:15:00', '2025-04-20 11:15:00', 'librarian1', 'librarian1');
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (4, 1, 4, '2025-04-04 16:45:00', '2025-04-19 16:45:00', NULL, 0, 1, 0, 0.00, '借阅中', '2025-04-04 16:45:00', '2025-05-06 10:30:44', 'librarian3', 'librarian3');
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (5, 2, 5, '2025-04-05 09:20:00', '2025-04-20 09:20:00', '2025-04-20 09:20:00', 0, 0, 0, 0.00, '按时归还', '2025-04-05 09:20:00', '2025-05-06 10:30:45', 'librarian2', 'librarian2');
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (6, 4, 3, '2025-04-06 14:30:00', '2025-04-21 14:30:00', NULL, 0, 1, 0, 0.00, '借阅中', '2025-04-06 14:30:00', '2025-05-15 23:10:04', 'librarian1', 'librarian1');
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (7, 1007, 7, '2025-04-07 10:00:00', '2025-04-22 10:00:00', '2025-04-25 10:00:00', 3, 0, 1, 1.50, '逾期归还，已罚款', '2025-04-07 10:00:00', '2025-04-25 10:00:00', 'librarian3', 'librarian3');
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (8, 5, 3, '2025-04-08 15:20:00', '2025-04-23 15:20:00', NULL, 0, 1, 0, 0.00, '借阅中', '2025-04-08 15:20:00', '2025-05-15 23:09:51', 'librarian2', 'librarian2');
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (9, 1009, 9, '2025-04-09 09:45:00', '2025-04-24 09:45:00', '2025-04-24 09:45:00', 0, 0, 0, 0.00, '按时归还', '2025-04-09 09:45:00', '2025-04-24 09:45:00', 'librarian1', 'librarian1');
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (10, 1010, 10, '2025-04-10 13:10:00', '2025-04-25 13:10:00', NULL, 0, 1, 0, 0.00, '借阅中', '2025-04-10 13:10:00', '2025-04-10 13:10:00', 'librarian3', 'librarian3');
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (11, 1011, 11, '2025-04-11 11:00:00', '2025-04-26 11:00:00', '2025-04-27 11:00:00', 1, 0, 1, 0.50, '逾期归还，已罚款', '2025-04-11 11:00:00', '2025-04-27 11:00:00', 'librarian2', 'librarian2');
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (12, 1012, 12, '2025-04-12 16:30:00', '2025-04-27 16:30:00', NULL, 0, 1, 0, 0.00, '借阅中', '2025-04-12 16:30:00', '2025-04-12 16:30:00', 'librarian1', 'librarian1');
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (13, 1013, 13, '2025-04-13 10:15:00', '2025-04-28 10:15:00', '2025-04-28 10:15:00', 0, 0, 0, 0.00, '按时归还', '2025-04-13 10:15:00', '2025-04-28 10:15:00', 'librarian3', 'librarian3');
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (14, 1014, 3, '2025-04-14 14:45:00', '2025-04-29 14:45:00', NULL, 0, 1, 0, 0.00, '借阅中', '2025-04-14 14:45:00', '2025-05-15 23:09:49', 'librarian2', 'librarian2');
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (15, 1015, 15, '2025-04-15 09:00:00', '2025-04-30 09:00:00', '2025-05-05 09:00:00', 5, 0, 1, 2.50, '逾期归还，已罚款', '2025-04-15 09:00:00', '2025-05-05 09:00:00', 'librarian1', 'librarian1');
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (501, 63, 16, '2024-12-04 00:00:00', '2025-01-03 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (502, 64, 17, '2024-09-10 00:00:00', '2024-10-10 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (503, 65, 18, '2025-03-01 00:00:00', '2025-03-31 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (504, 66, 19, '2024-07-20 00:00:00', '2024-08-19 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (505, 67, 20, '2024-10-19 00:00:00', '2024-11-18 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (506, 68, 21, '2024-11-05 00:00:00', '2024-12-05 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (507, 69, 22, '2025-01-01 00:00:00', '2025-01-31 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (508, 70, 23, '2024-04-10 00:00:00', '2024-05-10 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (509, 71, 24, '2023-12-22 00:00:00', '2024-01-21 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (510, 72, 25, '2024-06-15 00:00:00', '2024-07-15 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (511, 73, 26, '2025-03-10 00:00:00', '2025-04-09 00:00:00', '2025-04-08 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (512, 74, 27, '2024-09-20 00:00:00', '2024-10-20 00:00:00', '2024-10-15 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (513, 75, 28, '2025-02-01 00:00:00', '2025-03-03 00:00:00', '2025-03-10 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (514, 76, 29, '2024-11-20 00:00:00', '2024-12-20 00:00:00', '2024-12-18 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (515, 77, 30, '2024-10-18 00:00:00', '2024-11-17 00:00:00', '2024-12-01 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (516, 78, 31, '2024-06-19 00:00:00', '2024-07-19 00:00:00', '2024-07-10 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (517, 79, 32, '2025-01-08 00:00:00', '2025-02-07 00:00:00', '2025-02-03 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (518, 80, 33, '2024-12-07 00:00:00', '2025-01-06 00:00:00', '2025-01-04 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (519, 81, 34, '2024-05-23 00:00:00', '2024-06-22 00:00:00', '2024-07-02 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (520, 82, 35, '2024-03-30 00:00:00', '2024-04-29 00:00:00', '2024-04-29 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (521, 83, 36, '2025-03-25 00:00:00', '2025-04-24 00:00:00', '2025-04-20 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (522, 84, 37, '2024-12-01 00:00:00', '2024-12-31 00:00:00', '2024-12-29 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (523, 85, 38, '2025-02-22 00:00:00', '2025-03-24 00:00:00', '2025-03-30 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (524, 86, 39, '2024-11-15 00:00:00', '2024-12-15 00:00:00', '2024-12-13 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (525, 87, 40, '2025-01-27 00:00:00', '2025-02-26 00:00:00', '2025-03-05 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (526, 88, 41, '2024-10-16 00:00:00', '2024-11-15 00:00:00', '2024-11-20 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (527, 89, 42, '2024-09-26 00:00:00', '2024-10-26 00:00:00', '2024-10-23 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (528, 90, 43, '2025-04-01 00:00:00', '2025-05-01 00:00:00', '2025-05-01 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (529, 91, 44, '2024-06-28 00:00:00', '2024-07-28 00:00:00', '2024-08-02 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (530, 92, 45, '2024-05-13 00:00:00', '2024-06-12 00:00:00', '2024-06-11 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (531, 93, 46, '2025-04-25 00:00:00', '2025-05-25 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (532, 94, 47, '2025-04-10 00:00:00', '2025-05-10 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (533, 95, 48, '2025-04-26 00:00:00', '2025-05-26 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (534, 96, 49, '2025-05-01 00:00:00', '2025-05-31 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (535, 97, 50, '2025-05-10 00:00:00', '2025-06-09 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (536, 98, 51, '2025-04-28 00:00:00', '2025-05-28 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (537, 99, 52, '2025-05-04 00:00:00', '2025-06-03 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (538, 100, 53, '2025-04-29 00:00:00', '2025-05-29 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (539, 101, 54, '2025-05-03 00:00:00', '2025-06-02 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (540, 102, 55, '2025-04-30 00:00:00', '2025-05-30 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (541, 103, 56, '2025-03-15 00:00:00', '2025-05-14 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (542, 104, 57, '2025-04-01 00:00:00', '2025-05-31 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (543, 105, 58, '2025-05-05 00:00:00', '2025-07-04 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (544, 106, 59, '2025-04-20 00:00:00', '2025-06-19 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (545, 107, 60, '2025-05-09 00:00:00', '2025-07-08 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (546, 108, 61, '2025-05-08 00:00:00', '2025-07-07 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (547, 109, 62, '2025-04-15 00:00:00', '2025-06-14 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (548, 110, 63, '2025-03-20 00:00:00', '2025-05-19 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (549, 111, 64, '2025-05-01 00:00:00', '2025-06-30 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (550, 112, 65, '2025-05-06 00:00:00', '2025-07-05 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (551, 113, 16, '2024-08-14 00:00:00', '2024-09-13 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (552, 114, 17, '2025-01-28 00:00:00', '2025-02-27 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (553, 115, 18, '2024-10-30 00:00:00', '2024-11-29 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (554, 116, 19, '2024-11-16 00:00:00', '2024-12-16 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (555, 117, 20, '2024-12-15 00:00:00', '2025-01-14 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (556, 118, 21, '2025-02-10 00:00:00', '2025-03-12 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (557, 119, 22, '2024-09-05 00:00:00', '2024-10-05 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (558, 120, 23, '2024-06-12 00:00:00', '2024-07-12 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (559, 121, 24, '2024-08-20 00:00:00', '2024-09-19 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (560, 122, 25, '2024-04-14 00:00:00', '2024-05-14 00:00:00', NULL, 0, 2, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (561, 123, 26, '2024-12-01 00:00:00', '2024-12-31 00:00:00', '2024-12-29 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (562, 124, 27, '2024-08-05 00:00:00', '2024-09-04 00:00:00', '2024-09-01 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (563, 125, 28, '2024-03-09 00:00:00', '2024-04-08 00:00:00', '2024-04-09 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (564, 126, 29, '2024-11-23 00:00:00', '2024-12-23 00:00:00', '2024-12-22 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (565, 127, 30, '2025-01-02 00:00:00', '2025-02-01 00:00:00', '2025-01-31 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (566, 128, 31, '2025-02-12 00:00:00', '2025-03-14 00:00:00', '2025-03-13 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (567, 129, 32, '2024-10-16 00:00:00', '2024-11-15 00:00:00', '2024-11-08 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (568, 130, 33, '2025-01-23 00:00:00', '2025-02-22 00:00:00', '2025-02-18 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (569, 131, 34, '2024-11-28 00:00:00', '2024-12-28 00:00:00', '2024-12-20 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (570, 132, 35, '2025-01-14 00:00:00', '2025-02-13 00:00:00', '2025-02-12 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (571, 133, 36, '2024-09-12 00:00:00', '2024-10-12 00:00:00', '2024-10-08 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (572, 134, 37, '2024-11-16 00:00:00', '2024-12-16 00:00:00', '2024-12-12 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (573, 135, 38, '2024-12-22 00:00:00', '2025-01-21 00:00:00', '2025-01-19 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (574, 136, 39, '2025-01-28 00:00:00', '2025-02-27 00:00:00', '2025-02-22 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (575, 137, 40, '2024-10-25 00:00:00', '2024-11-24 00:00:00', '2024-11-21 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (576, 138, 41, '2025-01-12 00:00:00', '2025-02-11 00:00:00', '2025-01-25 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (577, 139, 42, '2025-03-10 00:00:00', '2025-04-09 00:00:00', '2025-03-28 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (578, 140, 43, '2024-09-10 00:00:00', '2024-10-10 00:00:00', '2024-10-06 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (579, 141, 44, '2025-03-10 00:00:00', '2025-04-09 00:00:00', '2025-04-07 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (580, 142, 45, '2025-04-01 00:00:00', '2025-05-01 00:00:00', '2025-04-30 00:00:00', 0, 0, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (581, 143, 46, '2025-05-06 00:00:00', '2025-06-05 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (582, 144, 47, '2025-05-08 00:00:00', '2025-06-07 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (583, 145, 48, '2025-05-09 00:00:00', '2025-06-08 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (584, 146, 49, '2025-05-13 00:00:00', '2025-06-12 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (585, 147, 50, '2025-05-01 00:00:00', '2025-05-31 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (586, 148, 51, '2025-04-30 00:00:00', '2025-05-30 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (587, 149, 52, '2025-04-29 00:00:00', '2025-05-29 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (588, 150, 53, '2025-05-10 00:00:00', '2025-06-09 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (589, 151, 54, '2025-05-13 00:00:00', '2025-06-12 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (590, 152, 55, '2025-05-03 00:00:00', '2025-06-02 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (591, 153, 56, '2025-05-01 00:00:00', '2025-06-30 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (592, 154, 57, '2025-05-05 00:00:00', '2025-07-04 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (593, 155, 58, '2025-04-28 00:00:00', '2025-06-27 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (594, 156, 59, '2025-05-13 00:00:00', '2025-07-12 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (595, 157, 60, '2025-05-09 00:00:00', '2025-07-08 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (596, 158, 61, '2025-04-21 00:00:00', '2025-06-20 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (597, 159, 62, '2025-05-07 00:00:00', '2025-07-06 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (598, 160, 63, '2025-04-15 00:00:00', '2025-06-14 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (599, 161, 64, '2025-05-04 00:00:00', '2025-07-03 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
INSERT INTO `borrow_record` (`record_id`, `copy_id`, `reader_id`, `borrow_date`, `due_date`, `return_date`, `overdue_days`, `status`, `is_overdue`, `fine`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (600, 162, 65, '2025-05-02 00:00:00', '2025-07-01 00:00:00', NULL, 0, 1, NULL, 0.00, NULL, '2025-05-15 12:00:00', '2025-05-15 12:00:00', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for reader
-- ----------------------------
DROP TABLE IF EXISTS `reader`;
CREATE TABLE `reader` (
  `reader_id` bigint NOT NULL AUTO_INCREMENT,
  `reader_number` varchar(50) NOT NULL COMMENT '学号/工号',
  `name` varchar(100) NOT NULL COMMENT '读者姓名',
  `grade_major` varchar(150) DEFAULT NULL COMMENT '年级专业',
  `gender` char(1) DEFAULT NULL COMMENT '性别，M-男，F-女',
  `avatar_url` varchar(255) DEFAULT NULL COMMENT '读者相片',
  `type` tinyint DEFAULT '1' COMMENT '读者类型：1=学生，2=职工',
  `borrow_limit` int DEFAULT '5' COMMENT '借书额度',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱地址',
  `phone` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `department_id` bigint NOT NULL COMMENT '所属部门ID',
  `status` tinyint DEFAULT '1' COMMENT '读者状态：1=活跃,0=禁用',
  `user_id` bigint DEFAULT NULL COMMENT '关联的用户ID',
  `remark` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '备注',
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_by` varchar(60) DEFAULT NULL COMMENT '创建人',
  `updated_by` varchar(60) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`reader_id`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `phone` (`phone`),
  KEY `reader_number` (`reader_number`),
  KEY `email_2` (`email`),
  KEY `phone_2` (`phone`),
  KEY `fk_user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb3 COMMENT='读者表';

-- ----------------------------
-- Records of reader
-- ----------------------------
BEGIN;
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (1, '20250001', '张三', '计算机科学与技术-2025级', 'M', 'https://example.com/avatar/1.jpg', 1, 5, 'zhangsan@email.com', '13800138001', 101, 1, 1, '计算机学院学生', '2025-04-01 09:00:00', '2025-04-01 09:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (2, '20250002', '李四', '软件工程-2025级', 'F', 'https://example.com/avatar/2.jpg', 1, 5, 'lisi@email.com', '13800138002', 102, 1, 2, '软件学院学生', '2025-04-01 09:05:00', '2025-04-01 09:05:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (3, '20250003', '王五', '机械工程-2025级', 'M', 'https://example.com/avatar/3.jpg', 1, 5, 'wangwu@email.com', '13800138003', 103, 1, 3, '机械学院学生', '2025-04-01 09:10:00', '2025-04-01 09:10:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (4, '20250004', '赵六', '电气工程-2025级', 'F', 'https://example.com/avatar/4.jpg', 1, 5, 'zhaoliu@email.com', '13800138004', 104, 1, 4, '电气学院学生', '2025-04-01 09:15:00', '2025-04-01 09:15:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (5, '20250005', '钱七', '自动化-2025级', 'M', 'https://example.com/avatar/5.jpg', 1, 5, 'qianqi@email.com', '13800138005', 105, 1, 5, '自动化学院学生', '2025-04-01 09:20:00', '2025-04-01 09:20:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (6, '20250006', '孙八', '土木工程-2025级', 'F', 'https://example.com/avatar/6.jpg', 1, 5, 'sunba@email.com', '13800138006', 106, 1, 6, '土木学院学生', '2025-04-01 09:25:00', '2025-04-01 09:25:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (7, '20250007', '周九', '化学工程-2025级', 'M', 'https://example.com/avatar/7.jpg', 1, 5, 'zhoujiu@email.com', '13800138007', 107, 1, 7, '化学学院学生', '2025-04-01 09:30:00', '2025-04-01 09:30:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (8, '20250008', '吴十', '生物工程-2025级', 'F', 'https://example.com/avatar/8.jpg', 1, 5, 'wushi@email.com', '13800138008', 108, 1, 8, '生命科学学院学生', '2025-04-01 09:35:00', '2025-04-01 09:35:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (9, '20250009', '郑十一', '数学-2025级', 'M', 'https://example.com/avatar/9.jpg', 1, 5, 'zhengshiyi@email.com', '13800138009', 109, 1, 9, '数学学院学生', '2025-04-01 09:40:00', '2025-04-01 09:40:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (10, '20250010', '王十二', '物理-2025级', 'F', 'https://example.com/avatar/10.jpg', 1, 5, 'wangshier@email.com', '13800138010', 110, 1, 10, '物理学院学生', '2025-04-01 09:45:00', '2025-04-01 09:45:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (11, '职工202501', '刘老师', '计算机科学与技术系-教师', 'M', 'https://example.com/avatar/11.jpg', 2, 10, 'liulaoshi@email.com', '13800138011', 201, 1, 11, '计算机学院教师', '2025-04-01 10:00:00', '2025-04-01 10:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (12, '职工202502', '陈老师', '软件工程系-教师', 'F', 'https://example.com/avatar/12.jpg', 2, 10, 'chenlaoshi@email.com', '13800138012', 202, 1, 12, '软件学院教师', '2025-04-01 10:05:00', '2025-04-01 10:05:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (13, '职工202503', '杨老师', '机械工程系-教师', 'M', 'https://example.com/avatar/13.jpg', 2, 10, 'yanglaoshi@email.com', '13800138013', 203, 1, 13, '机械学院教师', '2025-04-01 10:10:00', '2025-04-01 10:10:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (14, '职工202504', '黄老师', '电气工程系-教师', 'F', 'https://example.com/avatar/14.jpg', 2, 10, 'huanglaoshi@email.com', '13800138014', 204, 1, 14, '电气学院教师', '2025-04-01 10:15:00', '2025-04-01 10:15:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (15, '职工202505', '周老师', '自动化系-教师', 'M', 'https://example.com/avatar/15.jpg', 2, 10, 'zhoulaoshi@email.com', '13800138015', 205, 1, 15, '自动化学院教师', '2025-04-01 10:20:00', '2025-04-01 10:20:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (16, '20250016', '陆思齐', '计算机科学与技术-2025级', 'F', 'https://example.com/avatar/16.jpg', 1, 5, 'lusiqi@school.com', '13800138016', 101, 1, 16, '计算机学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (17, '20250017', '何佳俊', '软件工程-2025级', 'M', 'https://example.com/avatar/17.jpg', 1, 5, 'hejiajun@school.com', '13800138017', 102, 1, 17, '软件学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (18, '20250018', '任文静', '机械工程-2025级', 'F', 'https://example.com/avatar/18.jpg', 1, 5, 'renwenjing@school.com', '13800138018', 103, 1, 18, '机械学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (19, '20250019', '谢宇航', '电气工程-2025级', 'M', 'https://example.com/avatar/19.jpg', 1, 5, 'xieyuhang@school.com', '13800138019', 104, 1, 19, '电气学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (20, '20250020', '蔡婧怡', '自动化-2025级', 'F', 'https://example.com/avatar/20.jpg', 1, 5, 'caijingyi@school.com', '13800138020', 105, 1, 20, '自动化学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (21, '20250021', '邓志强', '土木工程-2025级', 'M', 'https://example.com/avatar/21.jpg', 1, 5, 'dengzhiqiang@school.com', '13800138021', 106, 1, 21, '土木学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (22, '20250022', '韩婷', '化学工程-2025级', 'F', 'https://example.com/avatar/22.jpg', 1, 5, 'hanting@school.com', '13800138022', 107, 1, 22, '化学学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (23, '20250023', '赖铭杰', '生物工程-2025级', 'M', 'https://example.com/avatar/23.jpg', 1, 5, 'laimingjie@school.com', '13800138023', 108, 1, 23, '生命科学学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (24, '20250024', '唐婉', '数学-2025级', 'F', 'https://example.com/avatar/24.jpg', 1, 5, 'tangwan@school.com', '13800138024', 109, 1, 24, '数学学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (25, '20250025', '龚逸飞', '物理-2025级', 'M', 'https://example.com/avatar/25.jpg', 1, 5, 'gongyifei@school.com', '13800138025', 110, 1, 25, '物理学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (26, '20250026', '邵雪', '计算机科学与技术-2025级', 'F', 'https://example.com/avatar/26.jpg', 1, 5, 'shaoxue@school.com', '13800138026', 101, 1, 26, '计算机学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (27, '20250027', '许少明', '软件工程-2025级', 'M', 'https://example.com/avatar/27.jpg', 1, 5, 'xushaoming@school.com', '13800138027', 102, 1, 27, '软件学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (28, '20250028', '杨慧', '机械工程-2025级', 'F', 'https://example.com/avatar/28.jpg', 1, 5, 'yanghui@school.com', '13800138028', 103, 1, 28, '机械学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (29, '20250029', '吕浩然', '电气工程-2025级', 'M', 'https://example.com/avatar/29.jpg', 1, 5, 'lvhaoran@school.com', '13800138029', 104, 1, 29, '电气学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (30, '20250030', '徐心怡', '自动化-2025级', 'F', 'https://example.com/avatar/30.jpg', 1, 5, 'xuxinyi@school.com', '13800138030', 105, 1, 30, '自动化学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (31, '20250031', '谭嘉诚', '土木工程-2025级', 'M', 'https://example.com/avatar/31.jpg', 1, 5, 'tanjiacheng@school.com', '13800138031', 106, 1, 31, '土木学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (32, '20250032', '郑美辰', '化学工程-2025级', 'F', 'https://example.com/avatar/32.jpg', 1, 5, 'zhengmeichen@school.com', '13800138032', 107, 1, 32, '化学学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (33, '20250033', '魏子昂', '生物工程-2025级', 'M', 'https://example.com/avatar/33.jpg', 1, 5, 'weiziang@school.com', '13800138033', 108, 1, 33, '生命科学学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (34, '20250034', '文雯', '数学-2025级', 'F', 'https://example.com/avatar/34.jpg', 1, 5, 'wenwen@school.com', '13800138034', 109, 1, 34, '数学学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (35, '20250035', '黄梓轩', '物理-2025级', 'M', 'https://example.com/avatar/35.jpg', 1, 5, 'huangzixuan@school.com', '13800138035', 110, 1, 35, '物理学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (36, '20250036', '顾琳', '计算机科学与技术-2025级', 'F', 'https://example.com/avatar/36.jpg', 1, 5, 'gulin@school.com', '13800138036', 101, 1, 36, '计算机学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (37, '20250037', '贺辰', '软件工程-2025级', 'M', 'https://example.com/avatar/37.jpg', 1, 5, 'hechen@school.com', '13800138037', 102, 1, 37, '软件学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (38, '20250038', '程思雨', '机械工程-2025级', 'F', 'https://example.com/avatar/38.jpg', 1, 5, 'chengsiyu@school.com', '13800138038', 103, 1, 38, '机械学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (39, '20250039', '温志宏', '电气工程-2025级', 'M', 'https://example.com/avatar/39.jpg', 1, 5, 'wenzhihong@school.com', '13800138039', 104, 1, 39, '电气学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (40, '20250040', '莫静', '自动化-2025级', 'F', 'https://example.com/avatar/40.jpg', 1, 5, 'mojing@school.com', '13800138040', 105, 1, 40, '自动化学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (41, '20250041', '尹天泽', '土木工程-2025级', 'M', 'https://example.com/avatar/41.jpg', 1, 5, 'yintianze@school.com', '13800138041', 106, 1, 41, '土木学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (42, '20250042', '迟晓芸', '化学工程-2025级', 'F', 'https://example.com/avatar/42.jpg', 1, 5, 'chixiaoyun@school.com', '13800138042', 107, 1, 42, '化学学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (43, '20250043', '钟正淳', '生物工程-2025级', 'M', 'https://example.com/avatar/43.jpg', 1, 5, 'zhongzhengchun@school.com', '13800138043', 108, 1, 43, '生命科学学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (44, '20250044', '赖萱', '数学-2025级', 'F', 'https://example.com/avatar/44.jpg', 1, 5, 'laixuan@school.com', '13800138044', 109, 1, 44, '数学学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (45, '20250045', '蒋乐博', '物理-2025级', 'M', 'https://example.com/avatar/45.jpg', 1, 5, 'jianglebo@school.com', '13800138045', 110, 1, 45, '物理学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (46, '20250046', '刘媛', '计算机科学与技术-2025级', 'F', 'https://example.com/avatar/46.jpg', 1, 5, 'liuyuan@school.com', '13800138046', 101, 1, 46, '计算机学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (47, '20250047', '杜锦程', '软件工程-2025级', 'M', 'https://example.com/avatar/47.jpg', 1, 5, 'dujincheng@school.com', '13800138047', 102, 1, 47, '软件学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (48, '20250048', '车汐雅', '机械工程-2025级', 'F', 'https://example.com/avatar/48.jpg', 1, 5, 'chexiya@school.com', '13800138048', 103, 1, 48, '机械学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (49, '20250049', '贾佳豪', '电气工程-2025级', 'M', 'https://example.com/avatar/49.jpg', 1, 5, 'jiajiahao@school.com', '13800138049', 104, 1, 49, '电气学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (50, '20250050', '常文慧', '自动化-2025级', 'F', 'https://example.com/avatar/50.jpg', 1, 5, 'changwenhui@school.com', '13800138050', 105, 1, 50, '自动化学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (51, '20250051', '石子安', '土木工程-2025级', 'M', 'https://example.com/avatar/51.jpg', 1, 5, 'shizian@school.com', '13800138051', 106, 1, 51, '土木学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (52, '20250052', '商苏菲', '化学工程-2025级', 'F', 'https://example.com/avatar/52.jpg', 1, 5, 'shangsufei@school.com', '13800138052', 107, 1, 52, '化学学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (53, '20250053', '章乐天', '生物工程-2025级', 'M', 'https://example.com/avatar/53.jpg', 1, 5, 'zhangletian@school.com', '13800138053', 108, 1, 53, '生命科学学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (54, '20250054', '郝歆', '数学-2025级', 'F', 'https://example.com/avatar/54.jpg', 1, 5, 'haoxin@school.com', '13800138054', 109, 1, 54, '数学学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (55, '20250055', '孔维泽', '物理-2025级', 'M', 'https://example.com/avatar/55.jpg', 1, 5, 'kongweize@school.com', '13800138055', 110, 1, 55, '物理学院学生', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (56, '职工202516', '王大明', '计算机科学与技术系-教师', 'M', 'https://example.com/avatar/56.jpg', 2, 10, 'wangdaming@school.com', '13800138056', 201, 1, 56, '计算机科学与技术系教师', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (57, '职工202517', '刘燕', '软件工程系-教师', 'F', 'https://example.com/avatar/57.jpg', 2, 10, 'liuyan@school.com', '13800138057', 202, 1, 57, '软件工程系教师', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (58, '职工202518', '陈立新', '机械工程系-教师', 'M', 'https://example.com/avatar/58.jpg', 2, 10, 'chenlixin@school.com', '13800138058', 203, 1, 58, '机械工程系教师', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (59, '职工202519', '黄心怡', '电气工程系-教师', 'F', 'https://example.com/avatar/59.jpg', 2, 10, 'huangxinyi@school.com', '13800138059', 204, 1, 59, '电气工程系教师', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (60, '职工202520', '赵志国', '自动化系-教师', 'M', 'https://example.com/avatar/60.jpg', 2, 10, 'zhaozhiguo@school.com', '13800138060', 205, 1, 60, '自动化系教师', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (61, '职工202521', '贾妍', '计算机科学与技术系-教师', 'F', 'https://example.com/avatar/61.jpg', 2, 10, 'jiayan@school.com', '13800138061', 201, 1, 61, '计算机科学与技术系教师', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (62, '职工202522', '袁炜', '软件工程系-教师', 'M', 'https://example.com/avatar/62.jpg', 2, 10, 'yuanwei@school.com', '13800138062', 202, 1, 62, '软件工程系教师', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (63, '职工202523', '杨菲', '机械工程系-教师', 'F', 'https://example.com/avatar/63.jpg', 2, 10, 'yangfei@school.com', '13800138063', 203, 1, 63, '机械工程系教师', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (64, '职工202524', '韩旭', '电气工程系-教师', 'M', 'https://example.com/avatar/64.jpg', 2, 10, 'hanxu@school.com', '13800138064', 204, 1, 64, '电气工程系教师', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
INSERT INTO `reader` (`reader_id`, `reader_number`, `name`, `grade_major`, `gender`, `avatar_url`, `type`, `borrow_limit`, `email`, `phone`, `department_id`, `status`, `user_id`, `remark`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (65, '职工202525', '邹雅', '自动化系-教师', 'F', 'https://example.com/avatar/65.jpg', 2, 10, 'zouya@school.com', '13800138065', 205, 1, 65, '自动化系教师', '2025-05-10 08:00:00', '2025-05-10 08:00:00', 'admin', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for reservation
-- ----------------------------
DROP TABLE IF EXISTS `reservation`;
CREATE TABLE `reservation` (
  `res_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `book_id` bigint NOT NULL COMMENT '图书ID',
  `reader_id` int NOT NULL COMMENT '读者ID',
  `reservation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '预约日期',
  `status` tinyint DEFAULT '1' COMMENT '预约状态：1=待处理，2=已完成，3=已取消,4-超期作废',
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `remark` varchar(1024) DEFAULT NULL COMMENT '备注',
  `created_by` varchar(60) DEFAULT NULL COMMENT '创建人',
  `updated_by` varchar(60) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`res_id`),
  KEY `reader_id` (`reader_id`),
  KEY `book_id` (`book_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb3 COMMENT='预约表';

-- ----------------------------
-- Records of reservation
-- ----------------------------
BEGIN;
INSERT INTO `reservation` (`res_id`, `book_id`, `reader_id`, `reservation_date`, `status`, `created_time`, `updated_time`, `remark`, `created_by`, `updated_by`) VALUES (1, 1, 1, '2025-04-01 15:00:00', 1, '2025-04-01 15:00:00', '2025-04-01 15:00:00', '预约图书《计算机科学导论》', 'admin', 'admin');
INSERT INTO `reservation` (`res_id`, `book_id`, `reader_id`, `reservation_date`, `status`, `created_time`, `updated_time`, `remark`, `created_by`, `updated_by`) VALUES (2, 2, 2, '2025-04-02 10:15:00', 1, '2025-04-02 10:15:00', '2025-04-02 10:15:00', '预约图书《数据结构》', 'admin', 'admin');
INSERT INTO `reservation` (`res_id`, `book_id`, `reader_id`, `reservation_date`, `status`, `created_time`, `updated_time`, `remark`, `created_by`, `updated_by`) VALUES (3, 3, 3, '2025-04-03 14:30:00', 2, '2025-04-03 14:30:00', '2025-04-03 14:30:00', '预约图书《操作系统》', 'admin', 'admin');
INSERT INTO `reservation` (`res_id`, `book_id`, `reader_id`, `reservation_date`, `status`, `created_time`, `updated_time`, `remark`, `created_by`, `updated_by`) VALUES (4, 4, 4, '2025-04-04 09:45:00', 1, '2025-04-04 09:45:00', '2025-04-04 09:45:00', '预约图书《计算机网络》', 'admin', 'admin');
INSERT INTO `reservation` (`res_id`, `book_id`, `reader_id`, `reservation_date`, `status`, `created_time`, `updated_time`, `remark`, `created_by`, `updated_by`) VALUES (5, 5, 5, '2025-04-05 11:00:00', 3, '2025-04-05 11:00:00', '2025-04-05 11:00:00', '预约图书《数据库系统》', 'admin', 'admin');
INSERT INTO `reservation` (`res_id`, `book_id`, `reader_id`, `reservation_date`, `status`, `created_time`, `updated_time`, `remark`, `created_by`, `updated_by`) VALUES (6, 6, 6, '2025-04-06 16:20:00', 1, '2025-04-06 16:20:00', '2025-04-06 16:20:00', '预约图书《文学名著选读》', 'admin', 'admin');
INSERT INTO `reservation` (`res_id`, `book_id`, `reader_id`, `reservation_date`, `status`, `created_time`, `updated_time`, `remark`, `created_by`, `updated_by`) VALUES (7, 7, 7, '2025-04-07 10:25:00', 2, '2025-04-07 10:25:00', '2025-04-07 10:25:00', '预约图书《中国古代史》', 'admin', 'admin');
INSERT INTO `reservation` (`res_id`, `book_id`, `reader_id`, `reservation_date`, `status`, `created_time`, `updated_time`, `remark`, `created_by`, `updated_by`) VALUES (8, 8, 8, '2025-04-08 15:40:00', 1, '2025-04-08 15:40:00', '2025-04-08 15:40:00', '预约图书《物理学导论》', 'admin', 'admin');
INSERT INTO `reservation` (`res_id`, `book_id`, `reader_id`, `reservation_date`, `status`, `created_time`, `updated_time`, `remark`, `created_by`, `updated_by`) VALUES (9, 9, 9, '2025-04-09 09:50:00', 3, '2025-04-09 09:50:00', '2025-04-09 09:50:00', '预约图书《高等数学》', 'admin', 'admin');
INSERT INTO `reservation` (`res_id`, `book_id`, `reader_id`, `reservation_date`, `status`, `created_time`, `updated_time`, `remark`, `created_by`, `updated_by`) VALUES (10, 10, 10, '2025-04-10 14:10:00', 1, '2025-04-10 14:10:00', '2025-04-10 14:10:00', '预约图书《管理学原理》', 'admin', 'admin');
INSERT INTO `reservation` (`res_id`, `book_id`, `reader_id`, `reservation_date`, `status`, `created_time`, `updated_time`, `remark`, `created_by`, `updated_by`) VALUES (11, 11, 11, '2025-04-11 11:30:00', 2, '2025-04-11 11:30:00', '2025-04-11 11:30:00', '预约图书《计算机组成原理》', 'admin', 'admin');
INSERT INTO `reservation` (`res_id`, `book_id`, `reader_id`, `reservation_date`, `status`, `created_time`, `updated_time`, `remark`, `created_by`, `updated_by`) VALUES (12, 12, 12, '2025-04-12 16:00:00', 1, '2025-04-12 16:00:00', '2025-04-12 16:00:00', '预约图书《软件工程》', 'admin', 'admin');
INSERT INTO `reservation` (`res_id`, `book_id`, `reader_id`, `reservation_date`, `status`, `created_time`, `updated_time`, `remark`, `created_by`, `updated_by`) VALUES (13, 13, 13, '2025-04-13 10:15:00', 3, '2025-04-13 10:15:00', '2025-04-13 10:15:00', '预约图书《机械设计基础》', 'admin', 'admin');
INSERT INTO `reservation` (`res_id`, `book_id`, `reader_id`, `reservation_date`, `status`, `created_time`, `updated_time`, `remark`, `created_by`, `updated_by`) VALUES (14, 14, 14, '2025-04-14 14:35:00', 1, '2025-04-14 14:35:00', '2025-04-14 14:35:00', '预约图书《电工学》', 'admin', 'admin');
INSERT INTO `reservation` (`res_id`, `book_id`, `reader_id`, `reservation_date`, `status`, `created_time`, `updated_time`, `remark`, `created_by`, `updated_by`) VALUES (15, 15, 15, '2025-04-15 09:25:00', 2, '2025-04-15 09:25:00', '2025-04-15 09:25:00', '预约图书《自动化控制原理》', 'admin', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `dept_id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL COMMENT '名称',
  `manager` varchar(30) DEFAULT NULL COMMENT '负责人',
  `remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
  `status` tinyint unsigned DEFAULT NULL COMMENT '部门状态：1=启用，0=禁用',
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_by` varchar(60) DEFAULT NULL COMMENT '创建人',
  `updated_by` varchar(60) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`dept_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=207 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='部门';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` (`dept_id`, `name`, `manager`, `remark`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (101, '计算机学院', '张教授', NULL, 1, '2025-05-04 17:26:44', '2025-05-05 17:33:37', NULL, NULL);
INSERT INTO `sys_dept` (`dept_id`, `name`, `manager`, `remark`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (102, '软件学院', '李教授', NULL, 1, '2025-05-04 17:26:44', '2025-05-05 17:33:41', NULL, NULL);
INSERT INTO `sys_dept` (`dept_id`, `name`, `manager`, `remark`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (103, '机械学院', '王教授', NULL, 1, '2025-05-04 17:26:44', '2025-05-05 17:33:46', NULL, NULL);
INSERT INTO `sys_dept` (`dept_id`, `name`, `manager`, `remark`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (104, '电气学院', '赵教授', NULL, 1, '2025-05-04 17:26:44', '2025-05-05 17:33:51', NULL, NULL);
INSERT INTO `sys_dept` (`dept_id`, `name`, `manager`, `remark`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (105, '自动化学院', '钱教授', NULL, 1, '2025-05-04 17:26:44', '2025-05-05 17:33:54', NULL, NULL);
INSERT INTO `sys_dept` (`dept_id`, `name`, `manager`, `remark`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (106, '土木学院', '孙教授', NULL, 1, '2025-05-04 17:26:44', '2025-05-05 19:20:49', NULL, NULL);
INSERT INTO `sys_dept` (`dept_id`, `name`, `manager`, `remark`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (107, '化学学院', '周教授', NULL, 1, '2025-05-04 17:26:44', '2025-05-05 17:34:16', NULL, NULL);
INSERT INTO `sys_dept` (`dept_id`, `name`, `manager`, `remark`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (108, '生命科学学院', '吴教授', NULL, 1, '2025-05-04 17:26:44', '2025-05-05 19:20:56', NULL, NULL);
INSERT INTO `sys_dept` (`dept_id`, `name`, `manager`, `remark`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (109, '数学学院', '郑教授', NULL, 1, '2025-05-04 17:26:44', '2025-05-05 19:20:52', NULL, NULL);
INSERT INTO `sys_dept` (`dept_id`, `name`, `manager`, `remark`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (110, '物理学院', '王教授', NULL, 1, '2025-05-04 17:26:44', '2025-05-05 19:21:46', NULL, NULL);
INSERT INTO `sys_dept` (`dept_id`, `name`, `manager`, `remark`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (201, '计算机科学与技术系', '刘教授', NULL, 1, '2025-05-04 17:26:44', '2025-05-05 19:21:49', NULL, NULL);
INSERT INTO `sys_dept` (`dept_id`, `name`, `manager`, `remark`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (202, '软件工程系', '陈教授', NULL, 1, '2025-05-04 17:26:44', '2025-05-05 19:21:53', NULL, NULL);
INSERT INTO `sys_dept` (`dept_id`, `name`, `manager`, `remark`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (203, '机械工程系', '杨教授', NULL, 1, '2025-05-04 17:26:44', '2025-05-05 19:21:55', NULL, NULL);
INSERT INTO `sys_dept` (`dept_id`, `name`, `manager`, `remark`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (204, '电气工程系', '黄教授', NULL, 1, '2025-05-04 17:26:44', '2025-05-05 19:21:58', NULL, NULL);
INSERT INTO `sys_dept` (`dept_id`, `name`, `manager`, `remark`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (205, '自动化系', '周教授', NULL, 1, '2025-05-04 17:26:44', '2025-05-05 19:22:04', NULL, NULL);
INSERT INTO `sys_dept` (`dept_id`, `name`, `manager`, `remark`, `status`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (206, 'testDept1', 'testDept1@za.com.cn', NULL, 0, '2025-05-05 17:26:53', '2025-05-05 19:22:15', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `authority_code` varchar(128) DEFAULT NULL COMMENT '权限标识符',
  `name` varchar(32) NOT NULL COMMENT '菜单名称',
  `parent_id` bigint unsigned DEFAULT NULL COMMENT '父菜单ID',
  `node_type` tinyint DEFAULT NULL COMMENT '菜单类型：1=目录型菜单，2=链接型菜单，3=按钮型菜单',
  `sort` tinyint DEFAULT NULL COMMENT '排序',
  `level` smallint DEFAULT NULL COMMENT '菜单层级',
  `status` tinyint DEFAULT NULL COMMENT '状态：1=启用，2=禁用',
  `link_url` varchar(512) DEFAULT NULL COMMENT '菜单链接',
  `icon` varchar(64) DEFAULT NULL COMMENT '菜单图标',
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `remark` varchar(128) DEFAULT NULL COMMENT '备注',
  `created_by` varchar(60) DEFAULT NULL COMMENT '创建人',
  `updated_by` varchar(60) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`),
  KEY `authority_code` (`authority_code`),
  KEY `parent_id` (`parent_id`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='菜单表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `role_code` varchar(32) NOT NULL COMMENT '角色代码',
  `role_name` varchar(50) NOT NULL COMMENT '角色名称',
  `description` varchar(255) DEFAULT NULL COMMENT '角色描述',
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `status` tinyint DEFAULT NULL COMMENT '角色状态：1=启用，0=禁用',
  `created_by` varchar(60) DEFAULT NULL COMMENT '创建人',
  `updated_by` varchar(60) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`role_id`),
  UNIQUE KEY `role_code` (`role_code`),
  KEY `role_code_2` (`role_code`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb3 COMMENT='角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`role_id`, `role_code`, `role_name`, `description`, `created_time`, `updated_time`, `status`, `created_by`, `updated_by`) VALUES (1, 'SUPER_ADMIN', '超级管理员', '拥有系统最高权限', '2025-05-02 16:04:18', '2025-05-02 16:40:04', 1, 'Admin', 'Admin');
INSERT INTO `sys_role` (`role_id`, `role_code`, `role_name`, `description`, `created_time`, `updated_time`, `status`, `created_by`, `updated_by`) VALUES (2, 'ADMIN', '管理员', '负责系统部分管理工作000000', '2025-05-02 16:04:18', '2025-05-17 22:29:51', 1, 'Admin', 'Admin');
INSERT INTO `sys_role` (`role_id`, `role_code`, `role_name`, `description`, `created_time`, `updated_time`, `status`, `created_by`, `updated_by`) VALUES (3, 'READER', '读者', '仅拥有阅读权限', '2025-05-02 16:04:18', '2025-05-02 16:47:23', 1, 'Admin', 'Admin');
INSERT INTO `sys_role` (`role_id`, `role_code`, `role_name`, `description`, `created_time`, `updated_time`, `status`, `created_by`, `updated_by`) VALUES (10, 'TESTER24', '测试角色1', '这是角色简介,系统管理员666', '2025-05-04 16:41:00', '2025-05-04 16:41:27', 0, NULL, NULL);
INSERT INTO `sys_role` (`role_id`, `role_code`, `role_name`, `description`, `created_time`, `updated_time`, `status`, `created_by`, `updated_by`) VALUES (11, 'TESTER', '测试角色1', '这是角色简介,系统管理员', '2025-05-04 16:41:40', '2025-05-04 16:41:40', 1, NULL, NULL);
INSERT INTO `sys_role` (`role_id`, `role_code`, `role_name`, `description`, `created_time`, `updated_time`, `status`, `created_by`, `updated_by`) VALUES (20, 'TESTER444', '测试角色1444', '这是角色简介,系统管理员', '2025-05-06 17:52:32', '2025-05-06 17:52:32', 1, NULL, NULL);
INSERT INTO `sys_role` (`role_id`, `role_code`, `role_name`, `description`, `created_time`, `updated_time`, `status`, `created_by`, `updated_by`) VALUES (22, 'TESTER3', '测试角色1', '这是角色简介,系统管理员0', '2025-05-17 22:31:17', '2025-05-17 22:53:54', 1, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '关联表ID',
  `role_id` bigint DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint DEFAULT NULL COMMENT '菜单ID',
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_by` varchar(60) DEFAULT NULL COMMENT '创建人',
  `updated_by` varchar(60) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`),
  UNIQUE KEY `menu_id` (`menu_id`,`role_id`),
  KEY `menu_id_2` (`menu_id`),
  KEY `role_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='角色菜单表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` varchar(64) NOT NULL COMMENT '用户名',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `email` varchar(100) NOT NULL COMMENT '邮箱地址',
  `mobile_phone` varchar(20) DEFAULT NULL COMMENT '手机号',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `avatar_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用户头像',
  `status` tinyint DEFAULT NULL COMMENT '用户状态：1=启用，0=禁用',
  `last_login_ip` varchar(45) DEFAULT NULL COMMENT '上次登录IP',
  `last_login_time` datetime DEFAULT NULL COMMENT '上一次登录时间',
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_by` varchar(60) DEFAULT NULL COMMENT '创建人',
  `updated_by` varchar(60) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`user_id`),
  KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `email`, `mobile_phone`, `remark`, `avatar_url`, `status`, `last_login_ip`, `last_login_time`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (1, 'testUser', 'password123', 'oldUsername2@163.com', '13800138001', '学生用户', 'https://example.com/avatar/1.jpg', 1, '192.168.1.1', '2025-04-01 09:00:00', '2025-04-01 09:00:00', '2025-05-02 23:27:54', 'admin', 'admin');
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `email`, `mobile_phone`, `remark`, `avatar_url`, `status`, `last_login_ip`, `last_login_time`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (2, 'lisi', 'password123', 'lisi@email.com', '13800138002', '学生用户', 'https://example.com/avatar/2.jpg', 1, '192.168.1.2', '2025-04-01 09:05:00', '2025-04-01 09:05:00', '2025-04-01 09:05:00', 'admin', 'admin');
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `email`, `mobile_phone`, `remark`, `avatar_url`, `status`, `last_login_ip`, `last_login_time`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (4, 'zhaoliu', 'password123', 'zhaoliu@email.com', '13800138004', '学生用户', 'https://example.com/avatar/4.jpg', 1, '192.168.1.4', '2025-04-01 09:15:00', '2025-04-01 09:15:00', '2025-04-01 09:15:00', 'admin', 'admin');
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `email`, `mobile_phone`, `remark`, `avatar_url`, `status`, `last_login_ip`, `last_login_time`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (5, 'qianqi', 'password123', 'qianqi@email.com', '13800138005', '学生用户', 'https://example.com/avatar/5.jpg', 1, '192.168.1.5', '2025-04-01 09:20:00', '2025-04-01 09:20:00', '2025-04-01 09:20:00', 'admin', 'admin');
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `email`, `mobile_phone`, `remark`, `avatar_url`, `status`, `last_login_ip`, `last_login_time`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (6, 'sunba', 'password123', 'sunba@email.com', '13800138006', '学生用户', 'https://example.com/avatar/6.jpg', 1, '192.168.1.6', '2025-04-01 09:25:00', '2025-04-01 09:25:00', '2025-04-01 09:25:00', 'admin', 'admin');
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `email`, `mobile_phone`, `remark`, `avatar_url`, `status`, `last_login_ip`, `last_login_time`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (7, 'zhoujiu', 'password123', 'zhoujiu@email.com', '13800138007', '学生用户', 'https://example.com/avatar/7.jpg', 1, '192.168.1.7', '2025-04-01 09:30:00', '2025-04-01 09:30:00', '2025-04-01 09:30:00', 'admin', 'admin');
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `email`, `mobile_phone`, `remark`, `avatar_url`, `status`, `last_login_ip`, `last_login_time`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (8, 'wushi', 'password123', 'wushi@email.com', '13800138008', '学生用户', 'https://example.com/avatar/8.jpg', 1, '192.168.1.8', '2025-04-01 09:35:00', '2025-04-01 09:35:00', '2025-04-01 09:35:00', 'admin', 'admin');
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `email`, `mobile_phone`, `remark`, `avatar_url`, `status`, `last_login_ip`, `last_login_time`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (9, 'zhengshiyi', 'password123', 'zhengshiyi@email.com', '13800138009', '学生用户', 'https://example.com/avatar/9.jpg', 1, '192.168.1.9', '2025-04-01 09:40:00', '2025-04-01 09:40:00', '2025-04-01 09:40:00', 'admin', 'admin');
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `email`, `mobile_phone`, `remark`, `avatar_url`, `status`, `last_login_ip`, `last_login_time`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (10, 'wangshier', 'password123', 'wangshier@email.com', '13800138010', '学生用户', 'https://example.com/avatar/10.jpg', 1, '192.168.1.10', '2025-04-01 09:45:00', '2025-04-01 09:45:00', '2025-04-01 09:45:00', 'admin', 'admin');
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `email`, `mobile_phone`, `remark`, `avatar_url`, `status`, `last_login_ip`, `last_login_time`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (11, 'liulaoshi', 'password123', 'liulaoshi@email.com', '13800138011', '教师用户', '/f3ded932-532c-42db-9b34-561f821ed810_avatart6.png', 1, '192.168.1.11', '2025-04-01 10:00:00', '2025-04-01 10:00:00', '2025-05-04 16:03:20', 'admin', 'admin');
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `email`, `mobile_phone`, `remark`, `avatar_url`, `status`, `last_login_ip`, `last_login_time`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (12, 'chenlaoshi', 'password123', 'chenlaoshi@email.com', '13800138012', '教师用户', '/0ee58fe5-bc71-46cf-a393-142da90663bb_avatart10.png', 1, '192.168.1.12', '2025-04-01 10:05:00', '2025-04-01 10:05:00', '2025-05-02 16:29:38', 'admin', 'admin');
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `email`, `mobile_phone`, `remark`, `avatar_url`, `status`, `last_login_ip`, `last_login_time`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (13, 'yanglaoshi', 'password123', 'yanglaoshi@email.com', '13800138013', '教师用户', '/2c16c5a3-b0aa-4d3d-bf36-5e0d91481bba_avatart10.png', 1, '192.168.1.13', '2025-04-01 10:10:00', '2025-04-01 10:10:00', '2025-05-04 16:02:19', 'admin', 'admin');
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `email`, `mobile_phone`, `remark`, `avatar_url`, `status`, `last_login_ip`, `last_login_time`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (14, 'huanglaoshi', 'password123', 'huanglaoshi@email.com', '13800138014', '教师用户3333', '/164a52e3-e3af-4c55-982a-600c2ed6e85d_avatart9.png', 1, '192.168.1.14', '2025-04-01 10:15:00', '2025-04-01 10:15:00', '2025-05-04 16:02:36', 'admin', 'admin');
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `email`, `mobile_phone`, `remark`, `avatar_url`, `status`, `last_login_ip`, `last_login_time`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (15, 'zhoulaoshi', 'password123', 'zhoulaoshi@email.com', '13800138015', '教师用户', '/47babc1e-cf72-4853-8f02-3ec26d8361d1_avatart8.png', 0, '192.168.1.15', '2025-04-01 10:20:00', '2025-04-01 10:20:00', '2025-05-02 09:54:51', 'admin', 'admin');
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `email`, `mobile_phone`, `remark`, `avatar_url`, `status`, `last_login_ip`, `last_login_time`, `created_time`, `updated_time`, `created_by`, `updated_by`) VALUES (38, 'testUser1', 'null123', 'testUser1@za.com.cn', '1345678901', '这是用户简介,系统管理员', NULL, 1, NULL, NULL, '2025-05-04 16:47:29', '2025-05-04 16:47:29', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '关联表ID',
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `role_id` bigint NOT NULL COMMENT '角色ID',
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_by` varchar(60) DEFAULT NULL COMMENT '创建人',
  `updated_by` varchar(60) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`role_id`),
  KEY `user_id_2` (`user_id`),
  KEY `role_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='用户角色关联表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- View structure for bookcopiesview
-- ----------------------------
DROP VIEW IF EXISTS `bookcopiesview`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `bookcopiesview` AS select `book_copy`.`copy_id` AS `copy_id`,`book_copy`.`book_id` AS `book_id`,`book_copy`.`barcode` AS `barcode`,`book_copy`.`location` AS `location`,`book_copy`.`status` AS `status`,`book_copy`.`created_time` AS `created_time`,`book_copy`.`updated_time` AS `updated_time`,`borrow_record`.`reader_id` AS `reader_id`,`reader`.`name` AS `name`,`book`.`title` AS `title`,`book`.`isbn` AS `isbn` from (((`book_copy` left join `book` on((`book_copy`.`book_id` = `book`.`book_id`))) left join `borrow_record` on((`book_copy`.`copy_id` = `borrow_record`.`copy_id`))) left join `reader` on((`borrow_record`.`reader_id` = `reader`.`reader_id`)));

-- ----------------------------
-- View structure for borrow_record_view
-- ----------------------------
DROP VIEW IF EXISTS `borrow_record_view`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `borrow_record_view` AS select `br`.`record_id` AS `record_id`,`br`.`copy_id` AS `copy_id`,`br`.`reader_id` AS `reader_id`,`br`.`borrow_date` AS `borrow_date`,`br`.`due_date` AS `due_date`,`br`.`return_date` AS `return_date`,`br`.`overdue_days` AS `overdue_days`,`br`.`is_overdue` AS `is_overdue`,`br`.`fine` AS `fine`,`br`.`remark` AS `remark`,`br`.`created_time` AS `created_time`,`br`.`updated_time` AS `updated_time`,`br`.`created_by` AS `created_by`,`br`.`updated_by` AS `updated_by`,`b`.`title` AS `book_name`,`b`.`isbn` AS `isbn`,`b`.`author` AS `author`,`b`.`book_id` AS `book_id`,`bc`.`barcode` AS `copy_barcode`,`bc`.`status` AS `copy_status`,`r`.`name` AS `reader_name`,`r`.`reader_number` AS `reader_number` from (((`borrow_record` `br` left join `reader` `r` on((`br`.`reader_id` = `r`.`reader_id`))) left join `book_copy` `bc` on((`br`.`copy_id` = `bc`.`copy_id`))) left join `book` `b` on((`bc`.`book_id` = `b`.`book_id`)));

SET FOREIGN_KEY_CHECKS = 1;
